Worksheet Commands

Specific worksheet commands are separate from the main window and are accessed through the Worksheet menu.

The worksheet commands and the buttons at the top of the worksheet are defined in the following table.

 

Worksheet Command	Description
Worksheet Menu Arrow	Displays the commands and functions for the selected cell(s)
Recalculate	Recalculates all formulas in all worksheets, whether open or closed; this function can also be accessed from the worksheet image (on drawing) context menu
Paste Criteria	Displays the Criteria dialog box; select search criteria to insert in a formula
Paste Function	Displays the Select Function dialog box; select function to be inserted in the formula (see Entering Formulas)
Database Headers	Toggles between displaying and hiding all worksheet database header rows
Format Cells	Opens the Format Cells dialog box, for setting the format and appearance of selected cells (see Formatting Worksheet Cells)
Column Width	Displays the Column Width dialog box. Set the width value of selected cells in the specified units. Click Standard Width to use the default width. The width of multiple selected columns can be adjusted at one time.
Row Height	Opens the Row Height dialog box; set the row height to automatically fit the selected cell contents, or set a specific row height in the specified units. The height of multiple selected rows can be adjusted at one time.
Preferences	Displays the Worksheet Preferences dialog box. Header and Footer text fields and the Margin settings apply to printed worksheets only. Select Show Grid to display the worksheet gridlines. Select Show Tabs to print worksheet column and row headers. Select Auto-recalc to recalculate all worksheet arithmetic functions when cells are edited. Click Font to specify the worksheet default font and size.
Clear Contents	Deletes the contents of the selected cells
Insert	Adds rows or columns to the worksheet. Select one or more rows or columns; the number selected determines the number inserted. Select Insert > Rows to add rows above the selected rows. Select Insert > Columns to add columns to the left of the selected columns. Use caution when inserting rows or columns. Depending on the type of cell references used in formulas, inserting rows or columns could change the values returned by a formula.
Delete	Deletes rows or columns from the worksheet. Select one or more rows or columns and select Delete > Rows or Delete > Columns. Use caution when deleting a row or column. Ensure that its cells are not part of a formula. Deleting cells that are part of a formula may change the values returned by the formula. Select Edit > Undo to undo the action.
Printer Setup	Displays the Printer Setup dialog box. This is the same as the standard Printer Setup dialog box; however, it only affects the printer information for the worksheet.
Print	Displays the Print dialog box, to print the current worksheet; this is the only way to print a worksheet from VectorWorks unless the worksheet is included as a part of the drawing
Descending Sort Icon	Sorts the database sub-rows in a column in descending order. To apply, select the database row to sort. Click and drag the icon to the desired column header. A numbered icon displays next to the column heading letter. The number indicates the sort precedence for that column. To remove the sort, click and drag the icon away from the column header cell.
Ascending Sort Icon	Sorts the database sub-rows in a column in ascending order. To apply, select the database row to sort. Click and drag the icon to the desired column header. A numbered icon displays next to the column heading letter. The number indicates the sort precedence for that column. To remove the sort, click and drag the icon away from the column header cell.
Summarize Icon	Summarizes identical database items in the desired column. Click and drag the icon to place it over the desired column header. An icon is placed next to the column heading letter. Identical items in the columns sub-rows are grouped together in a single sub-row. To remove the summary, click and drag the icon away from the column header cell.

Up to three sort icons and three summarize icons can be placed in the columns of a database row.

Worksheet Cell Context Menu

A worksheet context menu is activated by right-clicking while on a cell.

 

Menu Item	Description
Cut	Removes the contents of selected cells, temporarily storing the contents in the clipboard
Copy	Copies the contents of selected cells to the clipboard, where they are temporarily stored; the original contents remain in the worksheet
Paste	Places cell contents stored in the clipboard into the current cell or range of cells
Format Cells	Opens the Format Cells dialog box, for setting the format and appearance of selected cells (see Formatting Worksheet Cells)
Insert	Adds rows or columns to the worksheet. Select one or more rows or columns; the number selected determines the number inserted. Select Insert > Rows to add rows above the selected rows. Select Insert > Columns to add columns to the left of the selected columns. Use caution when inserting rows or columns. Depending on the type of cell references used in formulas, inserting rows or columns could change the values returned by a formula.
Delete	Deletes rows or columns from the worksheet. Select one or more rows or columns and select Delete > Rows or Delete > Columns. Use caution when deleting a row or column. Ensure that its cells are not part of a formula. Deleting cells that are part of a formula may change the values returned by the formula. Select Edit > Undo to undo the action.
Clear Contents	Deletes the contents of the selected cells
Pick Value from List (Design Series required)	Edits record information in database rows when selecting fields from a list

Worksheet Row Context Menu

An additional worksheet context menu is activated by clicking and holding while on a row header cell.

 

Menu Item	Description
Spreadsheet	Converts a database header row into a spreadsheet cells, keeping intact any information in the header row. This deletes all sub-rows and the information contained within them. Has no effect on Spreadsheet cells.
Database	Converts a row of spreadsheet cells into a database header row and opens the Criteria dialog box. Has no effect on database rows.
Set Criteria	Opens the Criteria dialog box for setting the criteria used to generate the database sub-rows. Available only when a database header row is clicked.
Edit Criteria	Opens the Criteria dialog box for editing the current criteria used to generate the database sub-rows. Available only when a database header row is clicked.
Select Data Items	Selects all objects on the drawing that meet the criteria for the database row. Available only when a database header row is clicked.

Clicking and holding while on a database row activates the Select Item command from the context menu. Select this command to select an individual database object, and change the view to display the selected object (see Selecting Database Objects).